Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TaxLineItem(TR_LTM_TX) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | TaxLineItem(TR_LTM_TX) |
IssuedToPartyID (FK) | A unique, system assigned identity for a Party. | ID_PRTY_ISS_TO | Identity | integer | TaxCertificate(PA_TX_CF) |
TaxCertificateSequenceNumber (FK) | A sequential counter used to uniquely identify a tax certificate for a specific party. | AI_PA_TX_CF | LineNumber | smallint | TaxCertificate(PA_TX_CF) |
ExemptTaxableAmount | The taxable amount that the Customer is exempt from. | MO_EXM_TXBL | MoneyShortRetail | decimal(7,2) | |
ExemptTaxAmount | The amount of Tax the Customer is exempt from paying. | MO_EXM_TX | Money | decimal(16,5) | |
ReasonCode (FK) | A reason code for the tax exemption. Typically the Customer belongs a special group, such foreign diplomats, religious bodies, etc. | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
CustomerExemptionID | Identifier presented by Customer to get this tax exemption. Not used if Customer presents an individualised tax exemption certificate. e.g. Flight Number in Duty Free stores at Airport. | ID_CT_EXM | Name | varchar(40) | |
CertificateNumber | The certificate number assigned to a purchaser by a TaxAuthority exempting the purchaser from tax in that aurhority. | ID_CF_TX_EXM | IdentityAlphaNumeric | varchar(20) | |
CertificateHolderName | The name of the individual or organization who holds the tax exemption certificate. | NM_HLDR_TX_EXM_CF | Name | varchar(40) | |